package com.itheima.mapper;

import com.itheima.pojo.domain.Dept;
import com.itheima.pojo.domain.Emp;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DeptMapper {

    @Select("select * from dept")
    List<Dept> list();

    @Delete("delete from clazz where id = #{id}")
    void deleteById(Integer id);

    @Insert("insert into dept(name,create_time,update_time) values(#{name},#{createTime},#{updateTime})")
    void insert(Dept dept);


    @Update("update dept set name=#{name} ,update_time=#{updateTime} where id = #{id} ")
    void update(Dept dept);

    @Select("select * from dept where id = #{id} ")
    Dept findById(Integer id);

//    @Delete("delete from emp where id=#{id}")
    void deleteEmpById(Integer id);

    @Delete("delete from dept where id = #{id}")
    void deleteDeptById(Integer id);

    @Select("select * from emp where dept_id = #{id}")
    List<Emp> listByDeptId(Integer id);
}
